package cn.com.aiton.educenter.mapper;

import cn.com.aiton.educenter.entity.PestsControl;
import cn.com.aiton.educenter.entity.vo.PestsQrcodeVo;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 防治业务数据表 Mapper 接口
 * </p>
 *
 * @author testAuthor
 * @since 2021-01-29
 */
public interface PestsControlMapper extends BaseMapper<PestsControl> {
    //查询某一天注册人数
    Integer countPestsDay(String day);
    //查询某一天注册人数
    Integer countPestsDayByProjectId(String day,String projectId);
    Integer countPestsDayByProjectIdAndMemberId(String day,String projectId,String memberId);
    //查询某一天注册人数
    List<PestsQrcodeVo> getPestsControlAndQrcode(String userId);
    IPage<PestsQrcodeVo> pagePestsControlAndQrcode(Page<PestsQrcodeVo> page, @Param(Constants.WRAPPER) Wrapper wrapper);
}
